The minimum required role permissions for the
ConstructSim Work Package Server Architecture is as
follows:
Application
Database Server Permissions
Admin permissions:
- Login Properties >
Server Roles >
public
- Login Properties >
Server Roles >
dbcreator
- Login Properties >
Server Roles >
sysadmin
Data Processing
Database Server Permissions
Primary admin (for example, ConstructSim project
creator):
- Login Properties >
Server Roles >
public
- Login Properties >
Securables > permissions for <your server> >
Create any database
Creator is the owner of the database. Also, creator
automatically gets the
db_owner fixed role for that database.
In order to support multiple data processing admin
personas:
Second admin (for example, anyone
who is not ConstructSim project creator):
- Login Properties >
Server Roles >
public
- Login Properties > User
Mappings > select <your database> >
db_owner
- Login Properties >
Server Roles >
dbcreator
Client Systems(s)
Permissions (ConstructSim Workstation)
ConstructSim Planner (Local
SQLExpress permissions):
- Login Properties >
Server Roles >
public
- Login Properties >
Securables > permissions for <local machine instance> >
Create any database